Overview

Dataset statistics

Number of variables41
Number of observations1013986
Missing cells14263504
Missing cells (%)34.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 GiB
Average record size in memory1.8 KiB

Variable types

CAT20
UNSUPPORTED14
NUM7

Reproduction

Analysis started2022-12-16 21:02:02.385646
Analysis finished2022-12-16 21:06:45.275177
Duration4 minutes and 42.89 seconds
Versionpandas-profiling v2.7.1
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
Agency has constant value "HPD" Constant
Complaint Type has constant value "HEAT/HOT WATER" Constant
Location Type has constant value "RESIDENTIAL BUILDING" Constant
Park Facility Name has constant value "Unspecified" Constant
Created Date has a high cardinality: 981277 distinct values High cardinality
Closed Date has a high cardinality: 278282 distinct values High cardinality
Incident Address has a high cardinality: 82894 distinct values High cardinality
Street Name has a high cardinality: 5068 distinct values High cardinality
City has a high cardinality: 87 distinct values High cardinality
Resolution Action Updated Date has a high cardinality: 213342 distinct values High cardinality
Community Board has a high cardinality: 71 distinct values High cardinality
Location has a high cardinality: 85329 distinct values High cardinality
BBL is highly correlated with Incident ZipHigh correlation
Incident Zip is highly correlated with BBLHigh correlation
Latitude is highly correlated with Y Coordinate (State Plane)High correlation
Y Coordinate (State Plane) is highly correlated with LatitudeHigh correlation
Longitude is highly correlated with X Coordinate (State Plane)High correlation
X Coordinate (State Plane) is highly correlated with LongitudeHigh correlation
Borough is highly correlated with Community Board and 1 other fieldsHigh correlation
Community Board is highly correlated with Borough and 1 other fieldsHigh correlation
Park Borough is highly correlated with Community Board and 1 other fieldsHigh correlation
Cross Street 1 has 1013986 (100.0%) missing values Missing
Cross Street 2 has 1013986 (100.0%) missing values Missing
Intersection Street 1 has 1013986 (100.0%) missing values Missing
Intersection Street 2 has 1013986 (100.0%) missing values Missing
Landmark has 1013986 (100.0%) missing values Missing
Facility Type has 1013986 (100.0%) missing values Missing
Due Date has 1013986 (100.0%) missing values Missing
BBL has 10690 (1.1%) missing values Missing
Vehicle Type has 1013986 (100.0%) missing values Missing
Taxi Company Borough has 1013986 (100.0%) missing values Missing
Taxi Pick Up Location has 1013986 (100.0%) missing values Missing
Bridge Highway Name has 1013986 (100.0%) missing values Missing
Bridge Highway Direction has 1013986 (100.0%) missing values Missing
Road Ramp has 1013986 (100.0%) missing values Missing
Bridge Highway Segment has 1013986 (100.0%) missing values Missing
Created Date is uniformly distributed Uniform
Unique Key has unique values Unique
Cross Street 1 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Cross Street 2 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Intersection Street 1 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Intersection Street 2 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Landmark is an unsupported type, check if it needs cleaning or further analysis Unsupported
Facility Type is an unsupported type, check if it needs cleaning or further analysis Unsupported
Due Date is an unsupported type, check if it needs cleaning or further analysis Unsupported
Vehicle Type is an unsupported type, check if it needs cleaning or further analysis Unsupported
Taxi Company Borough is an unsupported type, check if it needs cleaning or further analysis Unsupported
Taxi Pick Up Location is an unsupported type, check if it needs cleaning or further analysis Unsupported
Bridge Highway Name is an unsupported type, check if it needs cleaning or further analysis Unsupported
Bridge Highway Direction is an unsupported type, check if it needs cleaning or further analysis Unsupported
Road Ramp is an unsupported type, check if it needs cleaning or further analysis Unsupported
Bridge Highway Segment is an unsupported type, check if it needs cleaning or further analysis Unsupported

Variables

Unique Key
Real number (ℝ≥0)

UNIQUE
Distinct count1013986
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean43130257.056178294
Minimum35139948
Maximum52934200
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:06:46.232899image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum35139948
5-th percentile35519600.25
Q138214325.25
median41783978.5
Q348068128.75
95-th percentile52528982.75
Maximum52934200
Range17794252
Interquartile range (IQR)9853803.5

Descriptive statistics

Standard deviation5305137.844
Coefficient of variation (CV)0.1230026948
Kurtosis-1.123085758
Mean43130257.06
Median Absolute Deviation (MAD)3853779.5
Skewness0.2883078079
Sum4.373347683e+13
Variance2.814448754e+13
2022-12-16T16:06:46.394055image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
37748736 1 < 0.1%
 
52800024 1 < 0.1%
 
48587600 1 < 0.1%
 
38122011 1 < 0.1%
 
38111772 1 < 0.1%
 
48298278 1 < 0.1%
 
38113823 1 < 0.1%
 
52718112 1 < 0.1%
 
48521761 1 < 0.1%
 
38923535 1 < 0.1%
 
Other values (1013976) 1013976 > 99.9%
 
ValueCountFrequency (%) 
35139948 1 < 0.1%
 
35143918 1 < 0.1%
 
35143919 1 < 0.1%
 
35143920 1 < 0.1%
 
35143921 1 < 0.1%
 
ValueCountFrequency (%) 
52934200 1 < 0.1%
 
52931496 1 < 0.1%
 
52931495 1 < 0.1%
 
52931494 1 < 0.1%
 
52931482 1 < 0.1%
 

Created Date
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count981277
Unique (%)96.8%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
01/08/2018 12:00:00 AM
 
21
01/07/2018 12:00:00 AM
 
17
11/12/2017 12:00:00 AM
 
16
01/23/2017 12:00:00 AM
 
16
03/14/2017 12:00:00 AM
 
13
Other values (981272)
1013903
ValueCountFrequency (%) 
01/08/2018 12:00:00 AM 21 < 0.1%
 
01/07/2018 12:00:00 AM 17 < 0.1%
 
11/12/2017 12:00:00 AM 16 < 0.1%
 
01/23/2017 12:00:00 AM 16 < 0.1%
 
03/14/2017 12:00:00 AM 13 < 0.1%
 
11/23/2018 12:00:00 AM 13 < 0.1%
 
11/10/2017 12:00:00 AM 13 < 0.1%
 
03/27/2017 12:00:00 AM 12 < 0.1%
 
03/04/2017 12:00:00 AM 12 < 0.1%
 
01/01/2018 12:00:00 AM 12 < 0.1%
 
Other values (981267) 1013841 > 99.9%
 
2022-12-16T16:06:55.552601image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length22
Mean length22
Min length22
ValueCountFrequency (%) 
Decimal_Number 10 62.5%
 
Uppercase_Letter 3 18.8%
 
Other_Punctuation 2 12.5%
 
Space_Separator 1 6.2%
 
ValueCountFrequency (%) 
Common 13 81.2%
 
Latin 3 18.8%
 
ValueCountFrequency (%) 
ASCII 16 100.0%
 

Closed Date
Categorical

HIGH CARDINALITY
Distinct count278282
Unique (%)27.5%
Missing985
Missing (%)0.1%
Memory size7.7 MiB
10/24/2018 06:56:33 PM
 
293
11/28/2017 02:07:20 AM
 
259
11/16/2017 10:09:40 AM
 
244
03/28/2018 09:52:41 PM
 
241
11/11/2019 06:49:35 PM
 
239
Other values (278277)
1011725
ValueCountFrequency (%) 
10/24/2018 06:56:33 PM 293 < 0.1%
 
11/28/2017 02:07:20 AM 259 < 0.1%
 
11/16/2017 10:09:40 AM 244 < 0.1%
 
03/28/2018 09:52:41 PM 241 < 0.1%
 
11/11/2019 06:49:35 PM 239 < 0.1%
 
02/20/2019 02:09:53 AM 228 < 0.1%
 
02/14/2021 06:15:27 PM 180 < 0.1%
 
10/23/2018 02:09:20 AM 167 < 0.1%
 
10/27/2018 06:43:20 PM 162 < 0.1%
 
01/29/2019 09:45:59 PM 158 < 0.1%
 
Other values (278272) 1010830 99.7%
 
(Missing) 985 0.1%
 
2022-12-16T16:06:57.438444image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length22
Mean length21.98154314
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 55.6%
 
Uppercase_Letter 3 16.7%
 
Other_Punctuation 2 11.1%
 
Lowercase_Letter 2 11.1%
 
Space_Separator 1 5.6%
 
ValueCountFrequency (%) 
Common 13 72.2%
 
Latin 5 27.8%
 
ValueCountFrequency (%) 
ASCII 18 100.0%
 

Agency
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
HPD
1013986
ValueCountFrequency (%) 
HPD 1013986 100.0%
 
2022-12-16T16:06:57.676048image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length3
Mean length3
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 3 100.0%
 
ValueCountFrequency (%) 
Latin 3 100.0%
 
ValueCountFrequency (%) 
ASCII 3 100.0%
 

Agency Name
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
Department of Housing Preservation and Development
1013879
Division of Alternative Management
 
107
ValueCountFrequency (%) 
Department of Housing Preservation and Development 1013879 > 99.9%
 
Division of Alternative Management 107 < 0.1%
 
2022-12-16T16:06:57.882813image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length50
Mean length49.99831161
Min length34
ValueCountFrequency (%) 
Lowercase_Letter 16 72.7%
 
Uppercase_Letter 5 22.7%
 
Space_Separator 1 4.5%
 
ValueCountFrequency (%) 
Latin 21 95.5%
 
Common 1 4.5%
 
ValueCountFrequency (%) 
ASCII 22 100.0%
 

Complaint Type
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
HEAT/HOT WATER
1013986
ValueCountFrequency (%) 
HEAT/HOT WATER 1013986 100.0%
 
2022-12-16T16:06:58.068325image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length14
Mean length14
Min length14
ValueCountFrequency (%) 
Uppercase_Letter 7 77.8%
 
Other_Punctuation 1 11.1%
 
Space_Separator 1 11.1%
 
ValueCountFrequency (%) 
Latin 7 77.8%
 
Common 2 22.2%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

Descriptor
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
ENTIRE BUILDING
658553
APARTMENT ONLY
355433
ValueCountFrequency (%) 
ENTIRE BUILDING 658553 64.9%
 
APARTMENT ONLY 355433 35.1%
 
2022-12-16T16:06:58.347775image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length15
Mean length14.64946952
Min length14
ValueCountFrequency (%) 
Uppercase_Letter 15 93.8%
 
Space_Separator 1 6.2%
 
ValueCountFrequency (%) 
Latin 15 93.8%
 
Common 1 6.2%
 
ValueCountFrequency (%) 
ASCII 16 100.0%
 

Location Type
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
RESIDENTIAL BUILDING
1013986
ValueCountFrequency (%) 
RESIDENTIAL BUILDING 1013986 100.0%
 
2022-12-16T16:06:58.878934image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length20
Mean length20
Min length20
ValueCountFrequency (%) 
Uppercase_Letter 12 92.3%
 
Space_Separator 1 7.7%
 
ValueCountFrequency (%) 
Latin 12 92.3%
 
Common 1 7.7%
 
ValueCountFrequency (%) 
ASCII 13 100.0%
 

Incident Zip
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count190
Unique (%)< 0.1%
Missing7043
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean10713.993183328153
Minimum10001.0
Maximum12345.0
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:06:59.048353image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum10001
5-th percentile10023
Q110452
median10467
Q311223
95-th percentile11385
Maximum12345
Range2344
Interquartile range (IQR)771

Descriptive statistics

Standard deviation513.8201629
Coefficient of variation (CV)0.04795785793
Kurtosis-1.540497936
Mean10713.99318
Median Absolute Deviation (MAD)442
Skewness0.03758202946
Sum1.078838044e+10
Variance264011.1598
2022-12-16T16:06:59.168561image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11226 35469 3.5%
 
10458 30056 3.0%
 
10457 29707 2.9%
 
10467 29574 2.9%
 
10468 26945 2.7%
 
10452 25839 2.5%
 
10453 25705 2.5%
 
10462 22878 2.3%
 
10031 21526 2.1%
 
11225 20640 2.0%
 
Other values (180) 738604 72.8%
 
ValueCountFrequency (%) 
10001 1590 0.2%
 
10002 7712 0.8%
 
10003 5362 0.5%
 
10004 51 < 0.1%
 
10005 55 < 0.1%
 
ValueCountFrequency (%) 
12345 2 < 0.1%
 
11697 8 < 0.1%
 
11694 1847 0.2%
 
11693 467 < 0.1%
 
11692 1471 0.1%
 

Incident Address
Categorical

HIGH CARDINALITY
Distinct count82894
Unique (%)8.2%
Missing3
Missing (%)< 0.1%
Memory size7.7 MiB
89-21 ELMHURST AVENUE
 
9460
2176 TIEBOUT AVENUE
 
8134
9511 SHORE ROAD
 
4781
2040 BRONXDALE AVENUE
 
3987
1711 FULTON STREET
 
3165
Other values (82889)
984456
ValueCountFrequency (%) 
89-21 ELMHURST AVENUE 9460 0.9%
 
2176 TIEBOUT AVENUE 8134 0.8%
 
9511 SHORE ROAD 4781 0.5%
 
2040 BRONXDALE AVENUE 3987 0.4%
 
1711 FULTON STREET 3165 0.3%
 
1425 DR M L KING JR BOULEVARD 3066 0.3%
 
2750 HOMECREST AVENUE 2503 0.2%
 
2664 GRAND CONCOURSE 2463 0.2%
 
2090 EAST TREMONT AVENUE 2337 0.2%
 
1025 BOYNTON AVENUE 2301 0.2%
 
Other values (82884) 971786 95.8%
 
2022-12-16T16:07:00.157112image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length38
Mean length18.71441618
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 26 61.9%
 
Decimal_Number 10 23.8%
 
Other_Punctuation 2 4.8%
 
Lowercase_Letter 2 4.8%
 
Dash_Punctuation 1 2.4%
 
Space_Separator 1 2.4%
 
ValueCountFrequency (%) 
Latin 28 66.7%
 
Common 14 33.3%
 
ValueCountFrequency (%) 
ASCII 42 100.0%
 

Street Name
Categorical

HIGH CARDINALITY
Distinct count5068
Unique (%)0.5%
Missing3
Missing (%)< 0.1%
Memory size7.7 MiB
GRAND CONCOURSE
 
17957
BROADWAY
 
11402
TIEBOUT AVENUE
 
10020
ELMHURST AVENUE
 
9935
OCEAN AVENUE
 
8495
Other values (5063)
956174
ValueCountFrequency (%) 
GRAND CONCOURSE 17957 1.8%
 
BROADWAY 11402 1.1%
 
TIEBOUT AVENUE 10020 1.0%
 
ELMHURST AVENUE 9935 1.0%
 
OCEAN AVENUE 8495 0.8%
 
ST NICHOLAS AVENUE 7277 0.7%
 
MORRIS AVENUE 6983 0.7%
 
DR M L KING JR BOULEVARD 6087 0.6%
 
BEDFORD AVENUE 5378 0.5%
 
SHORE ROAD 5274 0.5%
 
Other values (5058) 925175 91.2%
 
2022-12-16T16:07:00.530056image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length32
Mean length14.12712503
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 26 63.4%
 
Decimal_Number 10 24.4%
 
Lowercase_Letter 2 4.9%
 
Space_Separator 1 2.4%
 
Dash_Punctuation 1 2.4%
 
Other_Punctuation 1 2.4%
 
ValueCountFrequency (%) 
Latin 28 68.3%
 
Common 13 31.7%
 
ValueCountFrequency (%) 
ASCII 41 100.0%
 

Cross Street 1
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Cross Street 2
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Intersection Street 1
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Intersection Street 2
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Address Type
Categorical

Distinct count1
Unique (%)< 0.1%
Missing6740
Missing (%)0.7%
Memory size7.7 MiB
ADDRESS
1007246
ValueCountFrequency (%) 
ADDRESS 1007246 99.3%
 
(Missing) 6740 0.7%
 
2022-12-16T16:07:00.702564image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length7
Mean length6.973411862
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 5 71.4%
 
Lowercase_Letter 2 28.6%
 
ValueCountFrequency (%) 
Latin 7 100.0%
 
ValueCountFrequency (%) 
ASCII 7 100.0%
 

City
Categorical

HIGH CARDINALITY
Distinct count87
Unique (%)< 0.1%
Missing6947
Missing (%)0.7%
Memory size7.7 MiB
BRONX
337191
BROOKLYN
300702
NEW YORK
222864
Elmhurst
 
14334
Jamaica
 
13189
Other values (82)
118759
ValueCountFrequency (%) 
BRONX 337191 33.3%
 
BROOKLYN 300702 29.7%
 
NEW YORK 222864 22.0%
 
Elmhurst 14334 1.4%
 
Jamaica 13189 1.3%
 
Flushing 11947 1.2%
 
Astoria 10734 1.1%
 
STATEN ISLAND 10323 1.0%
 
Ridgewood 7621 0.8%
 
Woodside 6663 0.7%
 
Other values (77) 71471 7.0%
 
(Missing) 6947 0.7%
 
2022-12-16T16:07:00.885534image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length19
Mean length7.236024955
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 26 52.0%
 
Lowercase_Letter 23 46.0%
 
Space_Separator 1 2.0%
 
ValueCountFrequency (%) 
Latin 49 98.0%
 
Common 1 2.0%
 
ValueCountFrequency (%) 
ASCII 50 100.0%
 

Landmark
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Facility Type
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Status
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
Closed
1013001
Open
 
985
ValueCountFrequency (%) 
Closed 1013001 99.9%
 
Open 985 0.1%
 
2022-12-16T16:07:01.085066image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length6
Mean length5.998057172
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 7 77.8%
 
Uppercase_Letter 2 22.2%
 
ValueCountFrequency (%) 
Latin 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

Due Date
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB
Distinct count24
Unique (%)< 0.1%
Missing65
Missing (%)< 0.1%
Memory size7.7 MiB
The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.
304469
The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.
241689
The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint.
135538
The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.
85005
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.
84354
Other values (19)
162866
ValueCountFrequency (%) 
The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. 304469 30.0%
 
The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint. 241689 23.8%
 
The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint. 135538 13.4%
 
The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. 85005 8.4%
 
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed. 84354 8.3%
 
The Department of Housing Preservation and Development contacted an occupant of the apartment and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint. 49306 4.9%
 
The Department of Housing Preservation and Development contacted a tenant in the building and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint. 39723 3.9%
 
The Department of Housing Preservation and Development inspected the following conditions. Violations were issued. Information about specific violations is available at www.nyc.gov/hpd. 32453 3.2%
 
The Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. 19503 1.9%
 
The following complaint conditions are still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection. 6434 0.6%
 
Other values (14) 15447 1.5%
 
2022-12-16T16:07:01.246440image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length382
Mean length271.6016612
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 24 38.7%
 
Uppercase_Letter 20 32.3%
 
Decimal_Number 10 16.1%
 
Other_Punctuation 4 6.5%
 
Close_Punctuation 1 1.6%
 
Open_Punctuation 1 1.6%
 
Dash_Punctuation 1 1.6%
 
Space_Separator 1 1.6%
 
ValueCountFrequency (%) 
Latin 44 71.0%
 
Common 18 29.0%
 
ValueCountFrequency (%) 
ASCII 62 100.0%
 

Resolution Action Updated Date
Categorical

HIGH CARDINALITY
Distinct count213342
Unique (%)21.0%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
11/08/2021 12:00:00 AM
 
2599
01/31/2021 12:00:00 AM
 
2575
02/06/2021 12:00:00 AM
 
2430
12/02/2021 12:00:00 AM
 
2139
11/17/2021 12:00:00 AM
 
2052
Other values (213337)
1002191
ValueCountFrequency (%) 
11/08/2021 12:00:00 AM 2599 0.3%
 
01/31/2021 12:00:00 AM 2575 0.3%
 
02/06/2021 12:00:00 AM 2430 0.2%
 
12/02/2021 12:00:00 AM 2139 0.2%
 
11/17/2021 12:00:00 AM 2052 0.2%
 
12/01/2021 12:00:00 AM 1967 0.2%
 
02/04/2021 12:00:00 AM 1952 0.2%
 
11/03/2021 12:00:00 AM 1917 0.2%
 
11/30/2021 12:00:00 AM 1867 0.2%
 
02/07/2021 12:00:00 AM 1852 0.2%
 
Other values (213332) 992636 97.9%
 
2022-12-16T16:07:02.543648image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length22
Mean length22
Min length22
ValueCountFrequency (%) 
Decimal_Number 10 62.5%
 
Uppercase_Letter 3 18.8%
 
Other_Punctuation 2 12.5%
 
Space_Separator 1 6.2%
 
ValueCountFrequency (%) 
Common 13 81.2%
 
Latin 3 18.8%
 
ValueCountFrequency (%) 
ASCII 16 100.0%
 

Community Board
Categorical

HIGH CARDINALITY
HIGH CORRELATION
Distinct count71
Unique (%)< 0.1%
Missing3
Missing (%)< 0.1%
Memory size7.7 MiB
12 MANHATTAN
 
59424
07 BRONX
 
52942
05 BRONX
 
49353
04 BRONX
 
49142
17 BROOKLYN
 
36040
Other values (66)
767082
ValueCountFrequency (%) 
12 MANHATTAN 59424 5.9%
 
07 BRONX 52942 5.2%
 
05 BRONX 49353 4.9%
 
04 BRONX 49142 4.8%
 
17 BROOKLYN 36040 3.6%
 
14 BROOKLYN 35505 3.5%
 
10 MANHATTAN 33296 3.3%
 
09 BRONX 33144 3.3%
 
09 BROOKLYN 29580 2.9%
 
09 MANHATTAN 29142 2.9%
 
Other values (61) 606415 59.8%
 
2022-12-16T16:07:02.714098image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length25
Mean length10.17407538
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 18 47.4%
 
Decimal_Number 10 26.3%
 
Lowercase_Letter 9 23.7%
 
Space_Separator 1 2.6%
 
ValueCountFrequency (%) 
Latin 27 71.1%
 
Common 11 28.9%
 
ValueCountFrequency (%) 
ASCII 38 100.0%
 

BBL
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
Distinct count73801
Unique (%)7.4%
Missing10690
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean2410982162.161106
Minimum0.0
Maximum5080470023.0
Zeros55
Zeros (%)< 0.1%
Memory size7.7 MiB
2022-12-16T16:07:02.904896image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1011950018
Q12024650001
median2042380027
Q33051050043
95-th percentile4091940007
Maximum5080470023
Range5080470023
Interquartile range (IQR)1026400042

Descriptive statistics

Standard deviation1014767451
Coefficient of variation (CV)0.4208938029
Kurtosis-0.788163981
Mean2410982162
Median Absolute Deviation (MAD)1006420007
Skewness0.222454617
Sum2.418928759e+15
Variance1.029752979e+18
2022-12-16T16:07:03.034705image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4015110001 9448 0.9%
 
2031430130 8133 0.8%
 
3061207502 4773 0.5%
 
2042850005 3964 0.4%
 
2039447501 3784 0.4%
 
3016910012 3165 0.3%
 
2025370047 3066 0.3%
 
3087640010 2470 0.2%
 
2033040010 2462 0.2%
 
2037140054 2301 0.2%
 
Other values (73791) 959730 94.6%
 
(Missing) 10690 1.1%
 
ValueCountFrequency (%) 
0 55 < 0.1%
 
1000020001 1 < 0.1%
 
1000070038 1 < 0.1%
 
1000077501 5 < 0.1%
 
1000110001 1 < 0.1%
 
ValueCountFrequency (%) 
5080470023 1 < 0.1%
 
5080460052 2 < 0.1%
 
5080450006 5 < 0.1%
 
5080390006 1 < 0.1%
 
5080370061 1 < 0.1%
 

Borough
Categorical

HIGH CORRELATION
Distinct count6
Unique (%)< 0.1%
Missing3
Missing (%)< 0.1%
Memory size7.7 MiB
BRONX
339152
BROOKLYN
302875
MANHATTAN
224734
QUEENS
136834
STATEN ISLAND
 
10385
ValueCountFrequency (%) 
BRONX 339152 33.4%
 
BROOKLYN 302875 29.9%
 
MANHATTAN 224734 22.2%
 
QUEENS 136834 13.5%
 
STATEN ISLAND 10385 1.0%
 
Unspecified 3 < 0.1%
 
(Missing) 3 < 0.1%
 
2022-12-16T16:07:03.219566image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length13
Mean length6.99952169
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 18 64.3%
 
Lowercase_Letter 9 32.1%
 
Space_Separator 1 3.6%
 
ValueCountFrequency (%) 
Latin 27 96.4%
 
Common 1 3.6%
 
ValueCountFrequency (%) 
ASCII 28 100.0%
 

X Coordinate (State Plane)
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count47269
Unique (%)4.7%
Missing7043
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean1006545.3696038405
Minimum914556.0
Maximum1067122.0
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:07:03.376599image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum914556
5-th percentile984760
Q1997353
median1005750
Q31015162
95-th percentile1032631
Maximum1067122
Range152566
Interquartile range (IQR)17809

Descriptive statistics

Standard deviation15122.62567
Coefficient of variation (CV)0.01502428617
Kurtosis2.011595376
Mean1006545.37
Median Absolute Deviation (MAD)8731
Skewness0.1128997854
Sum1.013533814e+12
Variance228693807.2
2022-12-16T16:07:03.516688image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1018372 9440 0.9%
 
1012350 8134 0.8%
 
973626 4773 0.5%
 
1021173 3964 0.4%
 
1005083 3078 0.3%
 
1003545 2848 0.3%
 
996391 2354 0.2%
 
1023616 2325 0.2%
 
1013537 2322 0.2%
 
1013908 2297 0.2%
 
Other values (47259) 965408 95.2%
 
(Missing) 7043 0.7%
 
ValueCountFrequency (%) 
914556 1 < 0.1%
 
914756 13 < 0.1%
 
914811 1 < 0.1%
 
914970 1 < 0.1%
 
915001 1 < 0.1%
 
ValueCountFrequency (%) 
1067122 2 < 0.1%
 
1067100 3 < 0.1%
 
1067099 1 < 0.1%
 
1067060 4 < 0.1%
 
1067046 2 < 0.1%
 

Y Coordinate (State Plane)
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count58007
Unique (%)5.8%
Missing7043
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean216783.51011030417
Minimum122081.0
Maximum271639.0
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:07:03.683452image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum122081
5-th percentile163174
Q1185589.5
median222226
Q3246572
95-th percentile258290
Maximum271639
Range149558
Interquartile range (IQR)60982.5

Descriptive statistics

Standard deviation32688.64739
Coefficient of variation (CV)0.150789363
Kurtosis-1.294529913
Mean216783.5101
Median Absolute Deviation (MAD)27820
Skewness-0.3071329701
Sum2.18288638e+11
Variance1068547668
2022-12-16T16:07:03.816139image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
211606 9435 0.9%
 
250589 8134 0.8%
 
163839 4773 0.5%
 
249273 3964 0.4%
 
246580 3069 0.3%
 
186786 2791 0.3%
 
152155 2354 0.2%
 
254950 2331 0.2%
 
246058 2320 0.2%
 
239723 2299 0.2%
 
Other values (57997) 965473 95.2%
 
(Missing) 7043 0.7%
 
ValueCountFrequency (%) 
122081 7 < 0.1%
 
122175 2 < 0.1%
 
122507 1 < 0.1%
 
122518 1 < 0.1%
 
122953 1 < 0.1%
 
ValueCountFrequency (%) 
271639 2 < 0.1%
 
271583 1 < 0.1%
 
271409 1 < 0.1%
 
271328 1 < 0.1%
 
271250 2 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
PHONE
521227
ONLINE
320033
MOBILE
172726
ValueCountFrequency (%) 
PHONE 521227 51.4%
 
ONLINE 320033 31.6%
 
MOBILE 172726 17.0%
 
2022-12-16T16:07:04.013880image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length6
Mean length5.485962331
Min length5
ValueCountFrequency (%) 
Uppercase_Letter 9 100.0%
 
ValueCountFrequency (%) 
Latin 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

Park Facility Name
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size7.7 MiB
Unspecified
1013986
ValueCountFrequency (%) 
Unspecified 1013986 100.0%
 
2022-12-16T16:07:04.162932image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length11
Mean length11
Min length11
ValueCountFrequency (%) 
Lowercase_Letter 8 88.9%
 
Uppercase_Letter 1 11.1%
 
ValueCountFrequency (%) 
Latin 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

Park Borough
Categorical

HIGH CORRELATION
Distinct count6
Unique (%)< 0.1%
Missing3
Missing (%)< 0.1%
Memory size7.7 MiB
BRONX
339152
BROOKLYN
302875
MANHATTAN
224734
QUEENS
136834
STATEN ISLAND
 
10385
ValueCountFrequency (%) 
BRONX 339152 33.4%
 
BROOKLYN 302875 29.9%
 
MANHATTAN 224734 22.2%
 
QUEENS 136834 13.5%
 
STATEN ISLAND 10385 1.0%
 
Unspecified 3 < 0.1%
 
(Missing) 3 < 0.1%
 
2022-12-16T16:07:04.319537image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length13
Mean length6.99952169
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 18 64.3%
 
Lowercase_Letter 9 32.1%
 
Space_Separator 1 3.6%
 
ValueCountFrequency (%) 
Latin 27 96.4%
 
Common 1 3.6%
 
ValueCountFrequency (%) 
ASCII 28 100.0%
 

Vehicle Type
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Taxi Company Borough
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Taxi Pick Up Location
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Bridge Highway Name
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Bridge Highway Direction
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Road Ramp
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Bridge Highway Segment
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1013986
Missing (%)100.0%
Memory size7.7 MiB

Latitude
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count85329
Unique (%)8.5%
Missing7043
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean40.76165547838995
Minimum40.50150695570338
Maximum40.91221758090332
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:07:04.524970image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum40.50150696
5-th percentile40.61454225
Q140.67603145
median40.77662647
Q340.84342648
95-th percentile40.87556453
Maximum40.91221758
Range0.4107106252
Interquartile range (IQR)0.1673950244

Descriptive statistics

Standard deviation0.08971736958
Coefficient of variation (CV)0.002201023696
Kurtosis-1.294606905
Mean40.76165548
Median Absolute Deviation (MAD)0.07633946117
Skewness-0.3071820114
Sum41044663.65
Variance0.008049206405
2022-12-16T16:07:04.879291image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
40.74742033 9410 0.9%
 
40.8544391 8133 0.8%
 
40.61637027 4773 0.5%
 
40.85079459 3964 0.4%
 
40.84345572 3066 0.3%
 
40.67934016 2790 0.3%
 
40.58429811 2354 0.2%
 
40.86640487 2321 0.2%
 
40.84195982 2313 0.2%
 
40.82459453 2295 0.2%
 
Other values (85319) 965524 95.2%
 
(Missing) 7043 0.7%
 
ValueCountFrequency (%) 
40.50150696 7 < 0.1%
 
40.5017699 2 < 0.1%
 
40.5026674 1 < 0.1%
 
40.5027036 1 < 0.1%
 
40.50389674 1 < 0.1%
 
ValueCountFrequency (%) 
40.91221758 2 < 0.1%
 
40.91206287 1 < 0.1%
 
40.91158732 1 < 0.1%
 
40.91136264 1 < 0.1%
 
40.91114555 2 < 0.1%
 

Longitude
Real number (ℝ)

HIGH CORRELATION
Distinct count85329
Unique (%)8.5%
Missing7043
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean-73.91949324785969
Minimum-74.25064221795266
Maximum-73.70093754842728
Zeros0
Zeros (%)0.0%
Memory size7.7 MiB
2022-12-16T16:07:05.084737image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum-74.25064222
5-th percentile-73.99816189
Q1-73.95274327
median-73.92238083
Q3-73.88835247
95-th percentile-73.82536934
Maximum-73.70093755
Range0.5497046695
Interquartile range (IQR)0.06439079828

Descriptive statistics

Standard deviation0.05457925523
Coefficient of variation (CV)-0.0007383607873
Kurtosis1.988998837
Mean-73.91949325
Median Absolute Deviation (MAD)0.03155598175
Skewness0.1106265704
Sum-74432716.29
Variance0.002978895101
2022-12-16T16:07:05.225061image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-73.87685301 9410 0.9%
 
-73.89842337 8133 0.8%
 
-74.03826694 4773 0.5%
 
-73.86653704 3964 0.4%
 
-73.92470475 3066 0.3%
 
-73.93043506 2790 0.3%
 
-73.95628992 2354 0.2%
 
-73.89411351 2321 0.2%
 
-73.85772539 2313 0.2%
 
-73.87729914 2295 0.2%
 
Other values (85319) 965524 95.2%
 
(Missing) 7043 0.7%
 
ValueCountFrequency (%) 
-74.25064222 1 < 0.1%
 
-74.24992323 13 < 0.1%
 
-74.24972456 1 < 0.1%
 
-74.24915576 1 < 0.1%
 
-74.2490386 1 < 0.1%
 
ValueCountFrequency (%) 
-73.70093755 2 < 0.1%
 
-73.7010117 3 < 0.1%
 
-73.70101524 1 < 0.1%
 
-73.70115242 3 < 0.1%
 
-73.70115317 1 < 0.1%
 

Location
Categorical

HIGH CARDINALITY
Distinct count85329
Unique (%)8.5%
Missing7043
Missing (%)0.7%
Memory size7.7 MiB
(40.747420328856705, -73.87685300997468)
 
9410
(40.85443910241399, -73.8984233658015)
 
8133
(40.61637026983262, -74.03826694457253)
 
4773
(40.850794587937656, -73.86653703997725)
 
3964
(40.84345572380287, -73.92470475387987)
 
3066
Other values (85324)
977597
ValueCountFrequency (%) 
(40.747420328856705, -73.87685300997468) 9410 0.9%
 
(40.85443910241399, -73.8984233658015) 8133 0.8%
 
(40.61637026983262, -74.03826694457253) 4773 0.5%
 
(40.850794587937656, -73.86653703997725) 3964 0.4%
 
(40.84345572380287, -73.92470475387987) 3066 0.3%
 
(40.67934015517145, -73.93043505876992) 2790 0.3%
 
(40.58429811390181, -73.95628992267918) 2354 0.2%
 
(40.86640486876999, -73.89411351479727) 2321 0.2%
 
(40.84195981610547, -73.85772539024822) 2313 0.2%
 
(40.824594531459304, -73.8772991398564) 2295 0.2%
 
Other values (85319) 965524 95.2%
 
(Missing) 7043 0.7%
 
2022-12-16T16:07:05.876741image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Length

Max length40
Mean length38.80981296
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 55.6%
 
Other_Punctuation 2 11.1%
 
Lowercase_Letter 2 11.1%
 
Close_Punctuation 1 5.6%
 
Open_Punctuation 1 5.6%
 
Space_Separator 1 5.6%
 
Dash_Punctuation 1 5.6%
 
ValueCountFrequency (%) 
Common 16 88.9%
 
Latin 2 11.1%
 
ValueCountFrequency (%) 
ASCII 18 100.0%
 

Interactions

2022-12-16T16:05:34.652730image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:35.400303image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:36.369905image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:37.054654image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:37.875300image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:38.755150image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:39.548375image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:40.232220image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:40.932185image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:41.926376image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:42.549403image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:43.188315image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:43.885847image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:44.515146image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:45.158563image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:45.811308image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:46.525337image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:47.219463image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:47.895190image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:48.543704image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:49.180246image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:49.790190image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:50.485057image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:51.137190image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:51.808469image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:52.524804image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:53.174390image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:54.001373image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:54.640014image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:55.288983image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:55.922806image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:56.564908image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:57.211204image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:57.877353image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:58.520393image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:05:59.225351image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:00.108132image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:00.834826image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:01.623884image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:02.341488image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:02.984858image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:03.606652image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:04.264219image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:04.891196image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:05.532458image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:06.146504image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:06.782210image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:07.410788image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:08.025788image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Correlations

2022-12-16T16:07:06.033936image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-12-16T16:07:06.345005image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-12-16T16:07:06.668272image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-12-16T16:07:06.972846image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.
2022-12-16T16:07:07.197197image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

2022-12-16T16:06:17.524579image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:24.412922image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:37.245398image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
2022-12-16T16:06:40.652324image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Sample

First rows

Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution DescriptionResolution Action Updated DateCommunity BoardBBLBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Open Data Channel TypePark Facility NamePark BoroughVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentLatitudeLongitudeLocation
03766628511/12/2017 12:00:00 AM01/22/2018 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERAPARTMENT ONLYRESIDENTIAL BUILDING10034.0165 SHERMAN AVENUESHERMAN AVENUENaNNaNNaNNaNADDRESSNEW YORKNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.01/22/2018 12:00:00 AM12 MANHATTAN1.022210e+09MANHATTAN1005613.0254344.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.864764-73.922764(40.86476431663921, -73.92276447154296)
13767527611/12/2017 12:00:00 AM04/08/2019 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERAPARTMENT ONLYRESIDENTIAL BUILDING10454.0353 EAST 141 STREETEAST 141 STREETNaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.04/08/2019 12:00:00 AM01 BRONX2.023040e+09BRONX1005674.0234944.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.811517-73.922606(40.81151682281859, -73.92260590193087)
23768238511/13/2017 12:00:00 AM11/13/2017 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11238.0374 PROSPECT PLACEPROSPECT PLACENaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.11/13/2017 12:00:00 AM08 BROOKLYN3.011600e+09BROOKLYN994136.0185823.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.676712-73.964359(40.67671244686174, -73.96435906406927)
33811258301/04/2018 12:00:00 AM03/18/2018 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10031.038 ST NICHOLAS PLACEST NICHOLAS PLACENaNNaNNaNNaNADDRESSNEW YORKNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.03/18/2018 12:00:00 AM09 MANHATTAN1.020540e+09MANHATTAN1000450.0241141.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.828537-73.941463(40.82853696054143, -73.94146261055029)
43879228203/27/2018 12:00:00 AM03/28/2018 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11216.0159 HALSEY STREETHALSEY STREETNaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.03/28/2018 12:00:00 AM03 BROOKLYN3.018380e+09BROOKLYN998843.0187787.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.682097-73.947385(40.68209667277928, -73.9473851721007)
53879331203/27/2018 12:00:00 AM03/30/2018 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11203.0374 EAST 49 STREETEAST 49 STREETNaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.03/30/2018 12:00:00 AM17 BROOKLYN3.046740e+09BROOKLYN1003252.0177119.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.652807-73.931519(40.65280703038938, -73.9315186685526)
63879986203/27/2018 12:00:00 AM04/04/2018 12:00:00 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10034.0165 SHERMAN AVENUESHERMAN AVENUENaNNaNNaNNaNADDRESSNEW YORKNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.04/04/2018 12:00:00 AM12 MANHATTAN1.022210e+09MANHATTAN1005613.0254344.0PHONEUnspecifiedMANHATTANNaNNaNNaNNaNNaNNaNNaN40.864764-73.922764(40.86476431663921, -73.92276447154296)
73687175108/04/2017 02:26:11 AM08/05/2017 02:46:11 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11201.0284 ATLANTIC AVENUEATLANTIC AVENUENaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.08/05/2017 02:46:11 AM02 BROOKLYN3.001810e+09BROOKLYN987141.0190205.0ONLINEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.688745-73.989576(40.68874508704761, -73.98957550708268)
83694998808/15/2017 08:04:39 AM08/17/2017 02:06:36 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERAPARTMENT ONLYRESIDENTIAL BUILDING11206.0417 LORIMER STREETLORIMER STREETNaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.08/17/2017 02:06:36 AM01 BROOKLYN3.030220e+09BROOKLYN998497.0197731.0MOBILEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.709391-73.948612(40.70939120268948, -73.94861163637752)
93695157608/15/2017 07:12:41 PM08/18/2017 02:14:04 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11238.0575 GRAND AVENUEGRAND AVENUENaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint.08/18/2017 02:14:04 AM08 BROOKLYN3.011480e+09BROOKLYN994712.0186288.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.677988-73.962282(40.67798810469399, -73.96228175142863)

Last rows

Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution DescriptionResolution Action Updated DateCommunity BoardBBLBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Open Data Channel TypePark Facility NamePark BoroughVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentLatitudeLongitudeLocation
10139764205331003/25/2019 11:07:02 AM03/27/2019 07:29:23 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11233.0205 SUMPTER STREETSUMPTER STREETNaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.03/27/2019 07:29:23 AM03 BROOKLYN3.015190e+09BROOKLYN1007129.0187133.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.680284-73.917512(40.680284053302664, -73.9175123666471)
10139774205330603/25/2019 09:45:28 AM03/27/2019 11:58:16 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11230.01585 EAST 14 STREETEAST 14 STREETNaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.03/27/2019 11:58:16 AM14 BROOKLYN3.067610e+09BROOKLYN995459.0161861.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.610940-73.959629(40.61094034785047, -73.95962920796566)
10139784205328603/25/2019 09:05:45 PM03/27/2019 02:07:47 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10452.01425 DR M L KING JR BOULEVARDDR M L KING JR BOULEVARDNaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 02:07:47 AM04 BRONX2.025370e+09BRONX1005083.0246580.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.843456-73.924705(40.84345572380287, -73.92470475387987)
10139794205331803/25/2019 09:21:58 PM03/27/2019 08:34:59 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10456.03475 3 AVENUE3 AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 08:34:59 AM03 BRONX2.023720e+09BRONX1010177.0241700.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.830048-73.906313(40.83004805755818, -73.90631274439146)
10139804205328703/25/2019 08:46:38 AM03/27/2019 05:27:21 PMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10458.02968 PERRY AVENUEPERRY AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 05:27:21 PM07 BRONX2.032920e+09BRONX1016331.0256308.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.870122-73.884005(40.87012244969979, -73.88400538088398)
10139814205330403/25/2019 04:44:13 PM03/27/2019 08:52:07 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10469.03478 FENTON AVENUEFENTON AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 08:52:07 AM12 BRONX2.047210e+09BRONX1026044.0259103.0MOBILEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.877753-73.848869(40.87775320807253, -73.84886891043506)
10139824205331703/25/2019 02:45:10 PM03/27/2019 04:56:33 PMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10462.02132 WALLACE AVENUEWALLACE AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 04:56:33 PM11 BRONX2.042920e+09BRONX1021647.0250439.0PHONEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.853993-73.864817(40.85399291289473, -73.86481720417432)
10139834205329203/25/2019 06:27:04 AM03/25/2019 09:14:17 PMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING11225.0486 BROOKLYN AVENUEBROOKLYN AVENUENaNNaNNaNNaNADDRESSBROOKLYNNaNNaNClosedNaNThe Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.03/25/2019 09:14:17 PM09 BROOKLYN3.013220e+09BROOKLYN999344.0180820.0PHONEUnspecifiedBROOKLYNNaNNaNNaNNaNNaNNaNNaN40.662973-73.945594(40.66297298421168, -73.94559442643347)
10139844205330503/25/2019 07:35:11 PM03/27/2019 02:07:56 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10461.02935 WILKINSON AVENUEWILKINSON AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.03/27/2019 02:07:56 AM10 BRONX2.042450e+09BRONX1031086.0249612.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.851678-73.830703(40.85167802151147, -73.83070293065111)
10139854205328803/25/2019 10:32:09 PM03/28/2019 02:07:44 AMHPDDepartment of Housing Preservation and DevelopmentHEAT/HOT WATERENTIRE BUILDINGRESIDENTIAL BUILDING10463.02834 HEATH AVENUEHEATH AVENUENaNNaNNaNNaNADDRESSBRONXNaNNaNClosedNaNThe Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.03/28/2019 02:07:44 AM08 BRONX2.032560e+09BRONX1010780.0257535.0ONLINEUnspecifiedBRONXNaNNaNNaNNaNNaNNaNNaN40.873509-73.904071(40.87350861612905, -73.90407114254262)